1 <?php
2
3 $dbServername = "localhost";
4 $dbUsername = "root";
5 $dbPassword = "password";
6 $dbName = "test";
7
8 $conn = mysqli_connect($dbServername, $dbUsername, $dbPassword, $dbName);
9 $show_id = mysqli_real_escape_string($conn,$_POST['show']);
10 $seats = mysqli_real_escape_string($conn,$_POST['seats']);
11
12 if (empty($seats) || empty($show_id))
13 {
14 session_start();
15 $_SESSION['khali'] = "One or more fields left empty for booking.<br> Please Try Again.";
16 header("Location: ../book.php?empty");
17 exit();
18 }
19
20 else
21 {
22 session_start();
23 $_SESSION['show_id']=$show_id;
24 $_SESSION['seats']=$seats;
25 $sql1= "SELECT seats from shows WHERE show_id='".$_SESSION['show_id']."' ";
26 mysqli_query($conn, $sql1) or die('Error seats');
27 $result=mysqli_query($conn, $sql1);
28 $row = mysqli_fetch_row($result);
29
30 if((int)$row[0]<=0)
31 {
32 header('Location: ../book.php');
33 $_SESSION['seats_out']="Sorry!<br>This Show is Sold out.";
34 exit();
35 }
36 elseif($seats>(int)$row[0])
37 {
38 header('Location: ../book.php');
39 $_SESSION['seats_remain']="Sorry!<br>Only seats ".$row[0]." remaining.";
40 exit();
41 }
42 else
43 {
44 $_SESSION['succ_book']="Tickets Booked Succesfully!<br>The Ticket Details are:";
45
46 $sql = "INSERT into booking (show_id,no_of_seats,booking_time,user_id) values ('$show_id','$seats',now(),'".$_SESSION['u_id']."')";
47
48 mysqli_query($conn, $sql) or die('Error');
49 $sql="CALL sub('".$show_id."','".$seats."')";
50 mysqli_query($conn, $sql) or die('Error procedure');
51
52
53 header('Location: ../book.php');
54 exit();
55 }
56 }
57
58 ?>